/*
 Navicat Premium Data Transfer

 Source Server         : sms
 Source Server Type    : MySQL
 Source Server Version : 50723
 Source Host           : 123.207.24.223:3306
 Source Schema         : sms

 Target Server Type    : MySQL
 Target Server Version : 50723
 File Encoding         : 65001

 Date: 20/06/2019 11:41:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for company_tbl
-- ----------------------------
DROP TABLE IF EXISTS `company_tbl`;
CREATE TABLE `company_tbl` (
  `company_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) NOT NULL,
  `company_legal` varchar(255) NOT NULL COMMENT '公司法人',
  `company_province` varchar(255) NOT NULL COMMENT '公司省份',
  `company_city` varchar(255) NOT NULL COMMENT '公司市区',
  `company_type` varchar(255) NOT NULL COMMENT '公司类型',
  `company_tel` varchar(255) NOT NULL COMMENT '公司公式电话',
  `company_other_tel` varchar(255) NOT NULL DEFAULT '-' COMMENT '其他的电话',
  `company_address` varchar(255) NOT NULL DEFAULT '-' COMMENT '公司地址',
  `company_website` varchar(255) NOT NULL DEFAULT '-' COMMENT '公司网址',
  `company_mail` varchar(255) NOT NULL DEFAULT '-' COMMENT '公司邮箱',
  `company_range` mediumtext NOT NULL COMMENT '公司经营范围',
  `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=591093530110464010 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of company_tbl
-- ----------------------------
BEGIN;
INSERT INTO `company_tbl` VALUES (1, 'adasd1231231', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-13 10:20:47', '2019-06-13 23:06:44');
INSERT INTO `company_tbl` VALUES (2, 'adasd', 'asdasd123123', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-13 10:24:21', '2019-06-13 23:06:44');
INSERT INTO `company_tbl` VALUES (3, 'adasd', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-13 23:06:44', '2019-06-13 23:06:44');
INSERT INTO `company_tbl` VALUES (4, 'adasd', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-13 23:06:44', '2019-06-13 23:06:44');
INSERT INTO `company_tbl` VALUES (588881956775923713, 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '17608891356', 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '2019-06-14 00:07:47', '2019-06-14 00:07:47');
INSERT INTO `company_tbl` VALUES (588881956775923714, 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '17608891356', 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '2019-06-14 00:07:47', '2019-06-14 00:07:47');
INSERT INTO `company_tbl` VALUES (588881956775923715, 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '17608891356', 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '2019-06-14 00:07:48', '2019-06-14 00:07:48');
INSERT INTO `company_tbl` VALUES (588882146140360704, 'adasd1231231', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-14 00:08:33', '2019-06-14 00:08:33');
INSERT INTO `company_tbl` VALUES (588882146140360705, 'adasd', 'asdasd123123', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-14 00:08:33', '2019-06-14 00:08:33');
INSERT INTO `company_tbl` VALUES (588882146140360706, 'adasd', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-14 00:08:33', '2019-06-14 00:08:33');
INSERT INTO `company_tbl` VALUES (588882146140360707, 'adasd', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-14 00:08:33', '2019-06-14 00:08:33');
INSERT INTO `company_tbl` VALUES (591090311707758592, '12312', '31231231', '12312', '31231', '2312', '31231', '23123', '1231231', '1231', '123123', '123123', '2019-06-20 02:21:52', '2019-06-20 02:21:52');
INSERT INTO `company_tbl` VALUES (591093530110464000, 'adasd1231231', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-20 02:34:39', '2019-06-20 02:34:39');
INSERT INTO `company_tbl` VALUES (591093530110464001, 'adasd', 'asdasd123123', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-20 02:34:39', '2019-06-20 02:34:39');
INSERT INTO `company_tbl` VALUES (591093530110464002, 'adasd', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-20 02:34:39', '2019-06-20 02:34:39');
INSERT INTO `company_tbl` VALUES (591093530110464003, 'adasd', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-20 02:34:40', '2019-06-20 02:34:40');
INSERT INTO `company_tbl` VALUES (591093530110464004, 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '17608891356', 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '2019-06-20 02:34:40', '2019-06-20 02:34:40');
INSERT INTO `company_tbl` VALUES (591093530110464005, 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '17608891356', 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '2019-06-20 02:34:40', '2019-06-20 02:34:40');
INSERT INTO `company_tbl` VALUES (591093530110464006, 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '17608891356', 'undefined', 'undefined', 'undefined', 'undefined', 'undefined', '2019-06-20 02:34:40', '2019-06-20 02:34:40');
INSERT INTO `company_tbl` VALUES (591093530110464007, 'adasd1231231', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-20 02:34:40', '2019-06-20 02:34:40');
INSERT INTO `company_tbl` VALUES (591093530110464008, 'adasd', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-20 02:34:40', '2019-06-20 02:34:40');
INSERT INTO `company_tbl` VALUES (591093530110464009, 'adasd', 'asdasd', 'asdasd', 'asdasda', 'sdasdas', '17608891356', '123123', 'asd', '-asdasd', 'asdasdasd-', 'asdasdasd', '2019-06-20 02:34:40', '2019-06-20 02:34:40');
COMMIT;

-- ----------------------------
-- Table structure for metric_tbl
-- ----------------------------
DROP TABLE IF EXISTS `metric_tbl`;
CREATE TABLE `metric_tbl` (
  `metric_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `metric_user` bigint(20) NOT NULL,
  `metric_left` int(11) NOT NULL DEFAULT '0',
  `metric_limit` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`metric_id`)
) ENGINE=InnoDB AUTO_INCREMENT=590115384347332609 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of metric_tbl
-- ----------------------------
BEGIN;
INSERT INTO `metric_tbl` VALUES (123, 2, 123, 123);
INSERT INTO `metric_tbl` VALUES (588773096564199424, 588755022133858304, 123, 12);
INSERT INTO `metric_tbl` VALUES (590115384347332608, 589045197409882112, 10000, 20);
COMMIT;

-- ----------------------------
-- Table structure for record_tbl
-- ----------------------------
DROP TABLE IF EXISTS `record_tbl`;
CREATE TABLE `record_tbl` (
  `record_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `record_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `record_user` bigint(20) NOT NULL,
  `record_template` bigint(20) NOT NULL,
  `record_company` bigint(20) NOT NULL,
  `record_content` mediumtext NOT NULL,
  PRIMARY KEY (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for template_tbl
-- ----------------------------
DROP TABLE IF EXISTS `template_tbl`;
CREATE TABLE `template_tbl` (
  `template_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `template_ext_id` varchar(50) NOT NULL,
  `template_name` varchar(50) NOT NULL,
  `template_text` mediumtext NOT NULL,
  `template_order` varchar(255) NOT NULL,
  `template_type` int(11) NOT NULL DEFAULT '1' COMMENT '0 系统内部，1用户使用',
  `template_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`template_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of template_tbl
-- ----------------------------
BEGIN;
INSERT INTO `template_tbl` VALUES (6, '166467', '修改手机号', '[ 摸商网 ] 尊敬的用户，您本次修改手机号的验证码为***，该验证码在15分钟内有效，如非本人操作，请忽略此短信', 'code', 1, '2019-06-14 13:48:59');
INSERT INTO `template_tbl` VALUES (8, '166465', '登录验证码', '[ 摸商网 ] 尊敬的用户，您本次登录的验证码为***，该验证码在15分钟内有效，如非本人操作，请忽略此短信', 'code', 2, '2019-06-14 13:50:05');
INSERT INTO `template_tbl` VALUES (9, '166468', '企业推荐	', '您好，有人通过[ 摸商网 ]平台关注到了你的企业，他想告诉您，您可能对***感兴趣，联系人：***，电话：***，这可能是不错的商机哦，抓紧联系吧。', 'userScope,userName,userPhone', 3, '2019-06-14 14:28:32');
INSERT INTO `template_tbl` VALUES (10, '166469', '商城推荐', '超值好货尽在[ 摸商网 ]，源头厂家在召唤你，***，联系人：***，电话：***，或许他的产品更适合你。', 'userCompanyName,userName,userPhone', 4, '2019-06-14 14:28:32');
INSERT INTO `template_tbl` VALUES (11, '166470', '信息更新通知', '您好，[ 摸商网 ]更新了信息了，这里或许有你想要的潜在资源哦！赶快登陆查看吧！', '', 5, '2019-06-14 14:28:32');
INSERT INTO `template_tbl` VALUES (12, '166466', '注册验证码', '【摸商网】尊敬的用户，您本次注册的验证码为{1}，该验证码在15分钟内有效，如非本人操作，请忽略此短信', 'code', 6, '2019-06-18 17:18:51');
COMMIT;

-- ----------------------------
-- Table structure for user_favorite_tbl
-- ----------------------------
DROP TABLE IF EXISTS `user_favorite_tbl`;
CREATE TABLE `user_favorite_tbl` (
  `favorite_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `favorite_company` bigint(20) NOT NULL,
  `favorite_user` bigint(20) NOT NULL,
  `favorite_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`favorite_id`)
) ENGINE=InnoDB AUTO_INCREMENT=591082134266187777 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_favorite_tbl
-- ----------------------------
BEGIN;
INSERT INTO `user_favorite_tbl` VALUES (588924402763304960, 2, 2, '2019-06-14 02:56:27');
INSERT INTO `user_favorite_tbl` VALUES (588924403639914496, 3, 2, '2019-06-14 02:56:27');
INSERT INTO `user_favorite_tbl` VALUES (588924404503941120, 4, 2, '2019-06-14 02:56:27');
INSERT INTO `user_favorite_tbl` VALUES (588924405447659520, 588881838425247744, 2, '2019-06-14 02:56:28');
INSERT INTO `user_favorite_tbl` VALUES (588924406940831744, 588881956775923713, 2, '2019-06-14 02:56:28');
INSERT INTO `user_favorite_tbl` VALUES (588924408668884992, 588881956775923715, 2, '2019-06-14 02:56:28');
INSERT INTO `user_favorite_tbl` VALUES (588924409469997056, 588882146140360704, 2, '2019-06-14 02:56:29');
COMMIT;

-- ----------------------------
-- Table structure for user_tbl
-- ----------------------------
DROP TABLE IF EXISTS `user_tbl`;
CREATE TABLE `user_tbl` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(50) NOT NULL,
  `user_phone` varchar(11) NOT NULL,
  `user_password` varchar(35) NOT NULL,
  `user_chname` varchar(50) NOT NULL,
  `user_company_name` varchar(255) NOT NULL,
  `user_scope` varchar(255) NOT NULL,
  `user_role` int(11) NOT NULL DEFAULT '0' COMMENT '0 common 1 vip 2 admin',
  `user_status` int(11) NOT NULL DEFAULT '0' COMMENT '0 common 1 unused',
  `user_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=591090476476796929 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_tbl
-- ----------------------------
BEGIN;
INSERT INTO `user_tbl` VALUES (1, 'admin', 'admin', 'admin1', 'adsfsdf', '1231231', '123123', 2, 0, '2019-06-13 13:47:59');
INSERT INTO `user_tbl` VALUES (2, 'wujiangpeng', '123456789', '123123', '12312312', ' asda', 'sdasda', 0, 1, '2019-06-13 15:51:08');
INSERT INTO `user_tbl` VALUES (588755022133858304, 'hbitmp', '17608891356', '17608891356', '1231231', '312312', '2312312', 0, 1, '2019-06-13 15:43:24');
INSERT INTO `user_tbl` VALUES (589045197409882112, '123123', '45535345', '123456', '123123', '12312312', '123123', 1, 0, '2019-06-14 10:56:29');
INSERT INTO `user_tbl` VALUES (589966409606631424, 'admin', '17608891355', '123456', '管理员', '摸商网', '暂时没有', 2, 0, '2019-06-16 23:57:07');
INSERT INTO `user_tbl` VALUES (591080299174301696, 'qwerty', '1234234234', '123456', '中国', '中国大法师', '暂时没有', 0, 0, '2019-06-20 01:42:05');
INSERT INTO `user_tbl` VALUES (591080707074560000, '12312312', '123123145', '123456', '312312', '123123', '3123123', 1, 0, '2019-06-20 01:43:42');
INSERT INTO `user_tbl` VALUES (591090476476796928, '12312312', '12312312', '123456', '312312', '231231', '31231', 2, 0, '2019-06-20 02:22:31');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
